package com.eascs.workflow.wf.dao;

import org.springframework.stereotype.Repository;
import com.eascs.workflow.common.dao.BaseDao;

@Repository
public class ProcessProvinceDao extends BaseDao {

	public String getProvince(String unitno){
		String sql="SELECT b.name FROM hr_units a,pub_provinces b  WHERE a.PROVINCE=b.code AND a.UNITNO = ?";
		return workflowJdbcSession.findString(sql, unitno);
	}

}

